An empirical analysis of database recovery costs
نویسندگان
چکیده
The time required for recovery from a failure is heavily influenced by hardware setup and workload characteristics. In bad but still realistic cases, the recovery required during restart can take hours. For a database system based on write-ahead logging, we performed a qualitative study of how hardware and software configurations affect the behavior of the database and, consequently, how this behavior affects recovery time after a system crash. With the relevant parameters identified in the qualitative study, we performed an empirical quantitative analysis of recovery costs in multiple scenarios. We show that recovery costs tend to get worse as hardware and software improve in efficiency, and we discuss possible approaches to make recovery time independent of system configurations and workload characteristics.
منابع مشابه
The Use of a Selective Database Technique in Order to Recover the Spectra of a Series of Acrylic Paints by the Principle Component Analysis
A procedure for an efficient recovering of reflectance spectra of Acrylic paint samples from CIE tristimulus color values is described. By fixing a certain criteria based on color difference value, the proposed technique preliminarily selects a series of suitable samples from a main dataset containing the reflectance values of a series of different Acrylic paint samples, based on the color ...
متن کاملDependence of Default Probability and Recovery Rate in Structural Credit Risk Models: Empirical Evidence from Greece
The main idea of this paper is to study the dependence between the probability of default and the recovery rate on credit portfolio and to seek empirically this relationship. We examine the dependence between PD and RR by theoretical approach. For the empirically methodology, we use the bootstrapped quantile regression and the simultaneous quantile regression. These methods allow to determinate...
متن کاملThe Relationship between Efficiency of Healthcare Costs and Economic Growth: Empirical Validation from Mediterranean Countries
The increase of healthcare costs improved as a rule the health of the population. Sometimes the positive effects of this expense are shaded off. On one hand, this expense improves the offer of the medical care. Other influential factors on the health of population, we quote as example the training, the lifestyle, the hygiene and the distribution of income. On the other hand the increase of thes...
متن کاملEconomic Analysis of Regional Versus General Anesthesia for Hip Fracture Surgery
Background: The economic burden of the treatment of hip fracture would be enormous, especially in countries like Iran with an aging population and limited financial resources. The choice of anesthetic technique for hip fracture surgery is controversial. We conducted this retrospective 4 year study to evaluate the effect of regional versus general anesthesia on the length of hospital stay and th...
متن کاملNew empirical failure criterion for shale
A new failure criterion was presented to predict the ultimate strength of shale under the triaxial and polyaxial state of stress. A database containing 93 datasets was obtained from the results of the uniaxial, triaxial, polyaxial compressive tests, an indirect tensile test was collected from reliable references, and this test was carried out on the shale samples taken from the southwestern oil...
متن کامل